Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Previous Next

NOTES.INI settings to re-enable Lotus 1-2-3 (.WKS) Import & Export . . .

Love how Lotus take away a feature that is invaluable for ad-hoc importing of data into Lotus Notes applications . . . and do not replace it with an alternative. Lotus, please add an Import/Export to .XLS (not .XLSx). Pretty please?

Anyhoo, you can edit the NOTES.INI of your 8.5 Lotus Notes client to use this work-around:

Enabling Import - Add a line like this:

VIEWIMP6=Lotus 1-2-3,0,_IWKSV,,.123,.WK1,.WK3,.WK4,.WKS,.WR1,.WRK,,4,

Enabling Export - Add a line like this:

VIEWEXP6=Lotus 1-2-3,0,_XWKS,,.123,.WK1,.WK3,.WK4,.WKS,.WR1,.WRK,,4,

Note: The VIEW[IMP/EXP]6 must not conflict with an existing value, so may need to be replaced by the next available number e.g VIEWIMP7, VIEWIMP8 etc.


Hth.


Feedback response number WEBB7RYGJ2 created by ~Chris Quetwebergettu on 05/12/2009

Import and Export in Lotus 123 form... (~Miriam Ciskich... 2.Feb.09)
. . We are investigating (~Mark Minalitle... 3.Feb.09)
. . . . Include support for Excel import (~Mark Minhipily... 4.Feb.09)
. . . . . . *Yes, this is important, especially... (~Anita Minaster... 12.May.09)
. . . . . . . . Exactly! (~Martha Asaboos... 15.May.09)
. . . . Exporting to Lotus 123 files (~Lisa Kigeropul... 14.Apr.09)
. . . . . . NOTES.INI settings to re-enable Lot... (~Chris Quetwebe... 12.May.09)
. . . . . . . . Thank you!!!! (~Laura Zekjipyl... 8.Jun.09)
. . . . . . . . I vote for simply making Excel impo... (~Sanjay Dwofana... 13.Aug.09)
. . . . . . . . . . If third-party apps isn't a problem... (~Arnold Zenjumi... 27.Sep.11)
. . . . . . . . Another thank you, and request to L... (~Yentl Bubrevit... 13.Aug.09)
. . . . Notes Help says it works (~Hank Bubjumive... 24.Aug.09)
. . Seems to be fixed in 8.5.1 (~Lorraine Dwohi... 18.Nov.09)
. . . . No need to have 1-2-3 (~Sven Ekfanaplo... 22.Nov.10)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS